Round punch time
Round the punch time to an effective time using the provided parameters.
Details
Rule Type
Time
Execution
Before punch
Parameters
Name | DataType | DefaultValue | Description |
---|---|---|---|
roundto | integer | 1 | Round the minutes to this nearest interval; e.g. 1=no rounding, 15=quarter hour |
bumpafter | integer | 1 | When "roundto" is greater than 1, this is the break point where the minutes round forward to the next "roundto" vs backwards to the prior; e.g. 7=minutes 0 - 7 round back to zero, while minutes 8 |
- 15 round forward to 15.
Decision Tree
Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.
Line# | Level1 | Level2 | Level3 | Comment |
---|---|---|---|---|
1 | Start | |||
2 | IF(FIND(PunchActions , Type ) notin IN,OUT ) → | ↓ | Only want IN/OUT actions | |
3 | ↓ | DONE | ||
4 | SET(EffectiveTime = ROUND_DATETIME(PunchTime , roundto , bumpafter )) | Round punch to nearest "roundto" | ||
5 | DONE |